Skip Headers

Oracle® Database SQL Reference 10g Release 2 (10.2) Part Number B14200-02 |
Home | Book List | Contents | Index | Master Index | Feedback

Previous | Next
| View PDF

# D Oracle Database Reserved Words

This appendix lists Oracle SQL reserved words. Words followed by an asterisk (*) are also ANSI reserved words.

Note: In addition to the following reserved words, Oracle uses system- generated names beginning with "`SYS_`" for implicitly generated schema objects and subobjects. Oracle discourages you from using this prefix in the names you explicitly provide to your schema objects and subobjects to avoid possible conflict in name resolution.

The `V$RESERVED_WORDS` data dictionary view provides additional information on all keywords, including whether the keyword is always reserved or is reserved only for particular uses. Please refer to Oracle Database Reference for more information.

`ACCESS`
`ADD *`
`ALL *`
`ALTER *`
`AND *`
`ANY *`
`AS *`
`ASC *`
`AUDIT`
`BETWEEN *`
`BY *`
`CHAR *`
`CHECK *`
`CLUSTER`
`COLUMN`
`COMMENT`
`COMPRESS`
`CONNECT *`
`CREATE *`
`CURRENT *`
`DATE *`
`DECIMAL *`
`DEFAULT *`
`DELETE *`
`DESC *`
`DISTINCT *`
`DROP *`
`ELSE *`
`EXCLUSIVE`
`EXISTS`
`FILE`
`FLOAT *`
`FOR *`
`FROM *`
`GRANT *`
`GROUP *`
`HAVING *`
`IDENTIFIED`
`IMMEDIATE *`
`IN *`
`INCREMENT`
`INDEX`
`INITIAL`
`INSERT *`
`INTEGER *`
`INTERSECT *`
`INTO *`
`IS *`
`LEVEL *`
`LIKE *`
`LOCK`
`LONG`
`MAXEXTENTS`
`MINUS`
`MLSLABEL`
`MODE`
`MODIFY`
`NOAUDIT`
`NOCOMPRESS`
`NOT *`
`NOWAIT`
`NULL *`
`NUMBER`
`OF *`
`OFFLINE`
`ON *`
`ONLINE`
`OPTION *`
`OR *`
`ORDER *`
`PCTFREE`
`PRIOR *`
`PRIVILEGES *`
`PUBLIC *`
`RAW`
`RENAME`
`RESOURCE`
`REVOKE *`
`ROW`
`ROWID`
`ROWNUM`
`ROWS *`
`SELECT *`
`SESSION *`
`SET *`
`SHARE`
`SIZE *`
`SMALLINT *`
`START`
`SUCCESSFUL`
`SYNONYM`
`SYSDATE`
`TABLE *`
`THEN *`
`TO *`
`TRIGGER`
`UID`
`UNION *`
`UNIQUE *`
`UPDATE *`
`USER *`
`VALIDATE`
`VALUES *`
`VARCHAR *`
`VARCHAR2`
`VIEW *`
`WHENEVER *`
`WHERE`
`WITH *`